Patrick,
The Posting you did for 2017 is correct. And yes you do not have to run Adjust Cost since you have Automatic Cost Posting = TRUE. In the 2nd pic are you showing the Posting Preview for the PI entry for 2017? That is impossible for a Posting Date = 1/1/2017 to post to multiple years. If you run Posting Preview and open the GL Entries what does the Posting Date, Accounts, and Amounts show?
Steve
Patrick,
That is amazing. I went to my Cronus database and tried to do the same thing posting a Purchase Invoice from 2 years ago and seeing my entries it did not cross years. The entry date was the same as the Posting Date of the document posted. I tried to trick the Purchase Order by Receiving the Items in 1/1/2020 and then Posting the Invoice on 1/1/2019 and the GL Entries are all dated 1/1/2019.
May I ask can you recreate this in a Cronus Database the same example? If not, I would recommend creating a General Journal Entry to correct the postings to the correct year.
Thanks,
Steve
Hi Steven, I try to reproduce the same in Cronus didn’t cross the year. So I will do the GL entries to post to correct year. I think, after I post the PI, I would reverse the GL entries for COGS and Inventory and then create the same entry with correct year. Correct?
i
Patrick,
I would agree with how you are thinking since all you want to do is correct inventory and updated all the Item Ledger Entries and Value Entries. The posting will update Inventory and COGS as the Items have been sold and the actual Inventory layers will reflect a Unit Cost that will be applied to the Sales Invoice and shipment.
Thanks,
Steve
Hi steve, couple of years went by, still the solution doesn’t seem to work or I am missing something. Because of the way I purchase and sell i.e supplier sends me an invoice of 1 qty of subscription item for a given month where I might have sold it to 5 other customers at different cost based on whatever they consumed or used. So instead of treating this as inventory, I am going to non-inventory/service item and I have GL account that posts all purchase costs instead of into Cog/inventory. However, what should I do for the previous years, where inventory and Cog are not reflected correctly? what is the best way . any ideas would be really appreciate it.
