SAP Business One Delivery Notes

[Former Member]

Hi,

Please could someone advise me if one could change the Account Determination of the Delivery Note? At the moment it posts the expense directly to the Cost of Sale and then posts the A/R Invoice to the Sales account.

We would like it to post the expense to a Balance Sheet Clearing Account when the Delivery Note is generated. When the A/R invoice is raised it can the post the Income to the Sales Account and the BP and the Expense from the Balance Sheet Clearing Account to the Cost of Sale.

Please help.

Kind regards,

JP

[Former Member · Accepted solution]

Jean-Pierre,

I don't believe you can change the JEs that transactions make (i.e. having the Invoice make an extra JE posting to move the money from the clearing to the COGS Account.

What you can do:

Change the Delivery Clearing Account in GL Determinations to the clearing account you want.

Then you can build a solution to automatically do all the JEs to move money from the clearing to COGS.

You could do this a number of different ways, ranging from simple, but very manual to fully automatic, but very complicated.

I'd think about using DTW first. A simple export of all applicable data (Del Notes/Invoices) first, then an import with DTW to create the JEs. You could link the JEs to docs using the REF fields and UDFs. You could use a auto-launcher to run this every night, week, month, etc.

You could also do an Add-On of course, that would do all this for you. It would simply look at a view of Del Notes/ invoices and make the JEs accordingly, possibly in real time or on interval.

I think a solution like these might solve your issue, but there is a downside that the JEs aren't directly linked to the Invoice (the way the Sales/BP posting is). Other than that, I bet it'd work nicely.

Hope that provides some insight on what is possible.

Brad Windecker

[Omega Business Solutions|http://www.omegagroup.com]

[JesperB1]

Hi Jean-Pierre,

No, this is not possible.

You would have to do these things manually, first setting up the balance sheet clearing account as COGS account in the account determination, and then for every Invoice that is created make a manual transfer from the Clearing Account to the COGS.

There is no setting that can be done in Business One so that this is done automatically.

Hope i helps.

Jesper

[Former Member]

Thanks Jesper,

Not what I was hoping for but thankyou for your quick response.

Regards,

JP