adempiere/adempiere

ADempiere Business Suite ERP/CRM/MFG/SCM/POS done the Bazaar way in an open and unabated fashion. Focus is on the Community that includes Subject Matter Specialists, Implementors and End-Users.

xakash

@xakash

sorry i mean on cloud server.

Stuart D. Gathman

@sdgathman

Yes. With all the caveats that come with cloud servers.

E.g. you lose access when your internet is down.

Stuart D. Gathman

@sdgathman

And the provider has access to your data. (Although reputable providers have strict rules about employees using access without permission.)

Michael McKay

@mckayERP

@sdgathman Part of the process when creating the refund should be to reverse the original payment allocation and then allocate the original payment and refund together. This leaves the aging report correct, showing the unpaid invoice.

Chathuranga Dissanayaka

@chathuranga-topra

Hi @all,
I am trying to configure adempiere replication processor. When the replication strategy is set the following error is rendered and close the applicable. The error comes with “java.lang.NoClassDeFounder:/org.slf4g/LoggerFactory”. Does anyone aware of this error?? please help to resolve it..

Chathuranga Dissanayaka

@chathuranga-topra

Exception in thread "AWT-EventQueue-0" java.lang.NoClassDefFoundError: org/slf4j/LoggerFactory
at org.apache.activemq.ActiveMQPrefetchPolicy.<clinit>(ActiveMQPrefetchPolicy.java:39)
at org.apache.activemq.ActiveMQConnectionFactory.<init>(ActiveMQConnectionFactory.java:84)
at org.apache.activemq.ActiveMQConnectionFactory.<init>(ActiveMQConnectionFactory.java:137)
at org.adempiere.model.ExportModelValidator.validateMQServer(ExportModelValidator.java:274)
at org.adempiere.model.ExportModelValidator.login(ExportModelValidator.java:246

Mukesh Vishwakarma

@MukeshSpring

Hi @chathuranga-topra : As you reported error message it seems LoggerFactory class is not exist slf4g package. Download updated slf4g jar file and build it again... http://www.java2s.com/Code/Jar/s/Downloadslf4jjar.htm

Stuart D. Gathman

@sdgathman

@mckayERP Oh, you mean reverse the allocation, not the payment.

Michael McKay

@mckayERP

Yes. If the payment has been reconciled, it shouldn't be voided. But the allocation can be as long as the period is open.

If the period is not open, I'm not sure. I don't know if you can allocate the reversed payment to the invoice. Perhaps manually in the View Allocation window or in the allocation tab of the payment. A paid invoice won't appear in the payment allocation window.

Stuart D. Gathman

@sdgathman

All three payments are in the same open period. It is a matter of taste which ACH the invoice should be allocated against. The second ACH is essentially replacing a lost check.

Except in the lost check scenario, you would void or reverse the lost check.

In the ACH case, all three payments clear the bank.

Chathuranga Dissanayaka

@chathuranga-topra

Hi @MukeshSpring Thank you very much..Hope It will work

Stuart D. Gathman

@sdgathman

Ok, to restart the books, I can generate a transaction (acctelem,dr,cr) to bring totals in line with CPA for start of 2019. Any pointer on generating the GJ automatically? Or should I opt for updating fact_acct_summary instead? (But then have to rerun everytime that gets changed prior to 2019.) And is there any problem with deleting the GJ detail records, adding them back, and reposting - after reconciling another period in the scrambled history ?

e-Evolution

@e-Evolution

hi @sdgathman the reason to purge history id by year close ?

Stuart D. Gathman

@sdgathman

@e-Evolution The history is a total mess. The starting balances for Jan 2012 do not balance. No bank reconciliations were done until 2019.

So my plan is to make a big journal entry in Dec 2018 to make 2019 normal, and then month by month reconcile the previous periods, and redoing the journal entry in Dec 2018. When prior reconciliation is complete, and starting balances fixed, then the journal entry in Dec 2018 should reflect just the drift in previous periods and can be permanent.

But I need to produce an accurate statement to convince management that Adempiere actually works when you actually do the data entry ...

Stuart D. Gathman

@sdgathman

I guess I should start out with adjusting fact_acct_summary. If it becomes too involved rerunning that, I can look into making the G/J entry.

Michael McKay

@mckayERP

@sdgathman You can easily import the correcting gl journal from excel and manage the corrections in excel. Each iteration would be a new gl journal you could add to a gl journal batch. You'd have to reactivate the batch for each import or create an entirely new one each time you update the past history.

The main issue with gl journal corrections is the loss or lack of the document information. For example, the aging report should match the AR account balances but the aging report only looks at invoices not gl journal entries.

Michael McKay

@mckayERP

To manage it in excel, consider creating two trial balances, one with the desired values and one with the current values from Adempiere. Subtract them to get the amounts for the gl journal and use these to generate the import file. Once you get that set up and automated it should be pretty quick to update and create the next correction.

Essentially, it's very similar to the process of managing a budget.

pmdw

@pmdw

Hi All
I am having a problem with a new clean install of Adempiere 390 LTS
Where would be the best place for a user to get some support advice on this? Thanks Peter

sorry 392LTS

testiranje1234

@testiranje1234

Ask dr google :adempiere installation guide

pmdw

@pmdw

Umm Ok I don't have problem installing Adempiere.
I have problem using Adempiere.
I have upgraded form 380 to 392 and I am having problems with cash book
transactions. I have rolled the upgrade back.
I have now installed Adempiere 392 on a separate device with just the Garden
world data. So nothing of mine in it. And I am still having issues with the
cash book.
So has the processes changed in the cash book from 380 to 390?
Is this the correct place to asking this type of question or is there a better
place to ask this type of question?

Stuart D. Gathman

@sdgathman

@mckayERP I already have this as a python program. It currently outputs a CPA trial balance, AD trial balance, or diff for a host,year,period

As a bonus, I can have it optionally add in a retained earnings transaction.

adaxa-steven

@adaxa-steven

"The main issue with gl journal corrections is the loss or lack of the document information. For example, the aging report should match the AR account balances but the aging report only looks at invoices not gl journal entries." .... a good reason not to post GL Journals to the AP and AR control and why those accounts are flagged as document controlled. Perhaps you can add a second GL account "AR adjustments" etc and post the journals affecting the prior period(s) there ... preferable after deleting the display logic on the BP field so you can at least record the BP relating to the adjustment ... then in the current period raise invoices or credit notes and allocate them to a Charge pointing to the AR Adjustments account so that it is returned to a zero value and the AR Control account then balances with the Aging Report.

Stuart D. Gathman

@sdgathman

Hmm. fact_acct_summary does not seem to include records with 0 transactions. This ought to be a case of LEFT JOIN, but then AmtAcctDr etc would need to default to 0 instead of null. I guess I can wrap in COALESCE().

And then I can't use c_acctschema_id from fact_acct_summary to calc the beginning balance. That comes from fact_acct. So I suppose I'll have to make acctschema a parameter.

Stuart D. Gathman

@sdgathman

I'm just not handy enough in SQL to make a trial balance view. I'll have to do it programmatically. postingtype is not available from period,elementvalue either. And other fields from fact_acct.

Stuart D. Gathman

@sdgathman

Huh. If I do a sum to get ending balance to drive the report, then I can LEFT JOIN the current period, and then subtract to get beginning balance.

e-Evolution

@e-Evolution

@sdgathman do you need the previos transaction ? becasue a good approach is starting with end balance to last period closeed and drop the history , this way you starting ok with next period

Stuart D. Gathman

@sdgathman

Yes. The sales data is accurate, and AP data mostly accurate. I need to work on sales forecasting when this problem is mitigated.

e-Evolution

@e-Evolution

the last adempiere version the sales forecasting can be imported in a diferrent table

Stuart D. Gathman

@sdgathman

The tools for that are in python - which I have no trouble integrating, but Adempiere, at least in 352a, doesn't like to talk to other components (via <somebrand>MQ, RESTFUL, other RPC method).

e-Evolution

@e-Evolution

C_SalesHistory this use to get the sales forecasting based on history

huy , the AD 352a is very version obsolete :-(

Stuart D. Gathman

@sdgathman

That is also on the table - and moving to 390 would be a good time to drop history. But first, I have to prove that Adempiere can actually produce a balance sheet...

It is easy enough to grab sales data from python using standard libraries for ARIMA and other modeling.

pmdw

@pmdw

Adempiere: Error when saving a cash-book receipt in a bank statement

Please note this process worked on:
(Adempiere 380 LTS on Ubuntu
with using jboss and a Postgres database )
but does not work on
(Adempiere 392 LTS on Ubuntu
with using jboss and a Postgres database )

Steps:

Raising of a cash-book record with 2 lines
(general receipts and bank account);
total record-balance is $0.00
(ie receipt is $+100, bank account is $-100);
status is complete and posted.
In a bank statement for the bank account,
a new line to allocate the cashbook receipt to the bank
account is created. The cashbook receipt is selected
and the receipt amount shows correctly.

3 a.) When saving on Adempiere 380 it records the transaction
without any issues.

b.) When trying to save using Adempiere 392 the entry/ line,
an error occurs.

It just says "Error:".

The error happens using the web client and the java client.
The error happens using the Garden world example data as a starting point.
Can any one else replicate this or is there a new set up requirement in 392?

marekmosiewicz

@marekmosiewicz

 @pmdw I'm trying to replicate your problem, but not sure which menu entry you use exactly.

pmdw

@pmdw

@marekmosiewicz Thanks for comming back on this. Its under Menu -> Open Items -> Cash Journal we are adding in the cash lines (step 1). We then go to Menu -> Open Items -> Bank statement and select the reciept (step 2) But cannot save it (step 3). Does this help?

marekmosiewicz

@marekmosiewicz

I do not have cashbook receipt reference in bank statement line by default on 3.9.2

@pmdw

Where communities thrive

People

Repo info

Activity