Notifications
Announcements
No record found.
How is it that when a sales invoice is posting with a different unit cost then what my inventory subledger shows? This is causing a GL to SL reconciliation issue . I thought the unit cost that goes on an SOP invoice was being grabbed from the inventory sub ledger? Apparently not.
The unit cost is pulled from inventory at the time of posting. The value is based on your inventory valuation method. The cost see in the posting journal will be the cost you will see in the ledger.
Richard, my company is unique in how we record inventory/voucher payables. When we order items from a manufacturer and receive them the POP goes to inventory at Gross. But when my AP team vouchers the payable, they take a deduction off the price. The deduction they take shows up only after they key the voucher, so my inventory subledger shows the POP at gross, a few days later when my AP team keys the voucher with the deduction they reduce inventory down to account for the deduction. So i guess what may be happening is if i sell an item before the deduction is posted to my inventory SL, then my SOP invoice is pulling gross cost- not net cost after the deduction.
I can only speak for the FIFO Perpetual inventory valuation method -- since it is the only method I have ever used. Once the SOP invoice is posted, the unit cost field is locked at whatever it was at posting.
If there is a cost adjustment later, you'll see it in the purchase receipts tables: that's where it corrects the costs when necessary, creates the GL entries to adjust inventory and COGS and creates entries for the Historical Inventory Trial Balance.
I created a sales transaction view that ignores the unit cost and extended cost fields in SOP and looks at the costs or adjusted costs that come from the purchase receipt tables (IV10200, IV10201). If you'd like to check it out let me know and I'll send it over to you!
Thanks.
Joe
Joseph,
Yes please! Your solution sounds ideal for my situation and I must admit I tried to do something similar to what you are explaining but I am not the best at joining tables together in Smartlist designer. After looking at some more HIV ledgers that is exactly what is happening. It makes running SOPs to do margin analysis useless because it only shows the cost at the time the SOP was posted, not what it truly was after the adjustments. If you can send it over to me that will be much appreciated ! THANKS
I needed to clean it up a bit since it was so heavily customized, but here is a link to my library of views:
jcmainc-my.sharepoint.com/.../EsX2CtnAJQVBoXA4vo6eESkBuhM9A1DE_ifcAyAL0kWiBQ
The ones for you are viewSales and viewSalesDocumentAnalysis (that's to replace the SOP Document Analysis report because it stinks).
I hope this helps!
I am in over my head. I viewed your file with all the SQL coding but what would I need to do to get my GP to run it? Is there an area in GP Smartlist Designer I can just copy and paste your code? I've never done something like this.
THANKS for all your help!
Sorry for the delay in getting back to you.
Here is an article about using a SQL view and adding it to SmartList Designer:
docs.microsoft.com/.../how-to-create-smartlist-designer-report-using-sql-view
To get the view into SQL Server, use SQL Server Management Studio, connect to your SQL Server, open the .sql files I sent you.
On the top line -- where it says "USE [TWO]..." change TWO to be whatever your company database name is.
Then just execute those two scripts. It will add the view to your GP company database you specified and be ready to use in SmartList Designer.
More than happy to talk further about this offline too.
Thank you.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 565 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
