Dynamics Community Forum Thread Details

Posting WiP with diverse dates

Hello,

I have the following question:
I have costs invoiced within one job card in the Job Ledger Entries. I am making calculation of the WiP and then I'm posting it in the General Ledger. Some time passes, I add another job task, charge further costs for this job, and then I calculate WiP costs again and I want to book them in the G/L with a different date. In this case, the system will withdraw the costs that were charged for the first time and post the total of the costs from job tasks no. 1 and no. 2 under a new set date. I know that I can exclude rows from the WiP cost calculation, but even that each time a newly calculated and posted WiP withdraws the previous entries and post only the included row to G/L. What I would like is to add each newly created cost with a new date to the already posted WiP.

Example:

I am calculating and posting the WiP to G/L for only Job Task: Cost 1 (1 000 LCY) Date 08.01.23

Then after some time I will collect the costs on Job task no.2 (Cost 2) and I would like to post/add the WiP costs to General Ledger with different date than no.1, e.g. 09.01.23

And thats what i get on WiP G/L Entries:

The last one WiP entry is reversed and only WiP costs for job no.2 are posted. I wanted to add the WiP costs from Job no.2 (with different date) to the previous posted WiP costs from Job no.1

Does anyone of you have any idea if this configuration is a standard default in the system and if it is possible to work around it?

Greetings,

Categories:

Dynamics 365 Business Central

Hi,

My understanding is that when WIP is calculated, all current WIP amounts are reversed and then the WIP amount is re-evaluated.

It is common practice to leave the WIP-Total of the Cost1 job task at "Total" and calculate the WIP for the second time.
That way, as of 09.01.23, 3,000LCY WIP will be posted to GL, and as of 08.01.23, 1,000LCY WIP will be posted to GL. Where is the problem with this?
In this case, only one WIP record (3,000 LCY) will be created on G/L Entries. 3000 LCY is the correct amount.
If you want to separate the WIP for 1000LCY record and the WIP for 2000LCY record on G/L, for example, assign different dimension code to each job task. Two G/L Entries would be created.

If you want to make 1000 LCY WIP to recognized cost as of 09.01.23, you need to convert 1000 LCY from WIP to recognized cost before calculating WIP for 2000 LCY. Then, set the Cost1 job task to Excluded and the Cost2 job task to Total to calculate WIP, and the WIP of 2000 LCY would be posted to G/L.

See below blog post, it might help you to know how to "make 1000 LCY WIP to recognized cost as of 09.01.23 "
Tips & Tricks of JOB WIP Calculation | IT長のネタ帳 (d3654.be)

I hope this helps you.

S.Kawamura

Quick Links