Hi, I'm having issues with my GL Impact on Cash Sa...
# accountingm
Mark Robinson
09/09/2022, 6:01 PMHi, I'm having issues with my GL Impact on Cash Sale and Cash Refund transaction records.
To my understanding, the items in question should show their purchase price as the COGS value, and all other pricing is aligned with how the item is set up, however the value I'm seeing on the GL Impact subtab doesn't match the Purchase Price.
Any help is appreciated, I have been looking all over to find any instructions or guides to help me understand how this should be set up and so far I'm just not seeing it.
r
RJMNS
09/09/2022, 8:44 PMIt's going to depend on your costing method. Purchase Price probably is not going to be the same as COGS unless you're buying things for the same price 100% of the time.
m
Mark Robinson
09/09/2022, 8:47 PMSo I'm playing with this in a sandbox, and I have tried updating the costing method at the item record, but even after saving that and re-creating the Cash Sale the GL value is still showing a number that I don't expect.
Mark Robinson
09/09/2022, 8:55 PMIs there a different way to change the costing method other than on the item?
Mark Robinson
09/09/2022, 9:00 PMI just spotted a suiteanswers article that talks about how to update the costing method.
https://suiteanswers.custhelp.com/app/answers/detail/a_id/101886/loc/en_US
Mark Robinson
09/09/2022, 9:00 PMI'll give that a shot and see if it corrects my issue
Mark Robinson
09/09/2022, 9:11 PMI'm kind of shocked at how difficult it is to do a reset on this value, but I guess it makes sense that making this too easy would open up the door for some potentially very bad things to happen
Mark Robinson
09/09/2022, 9:49 PMIt's looking like I might need to dump and rebuild all inventory items to ensure that this is set up correctly.
Can someone confirm for me that this may be the best way to correct these incorrect values?
I am seeing them everywhere, likely due to something that was missed during the initial creation or implementation of this NetSuite instance.
r
RJMNS
09/09/2022, 10:48 PMI'd test it, but yes taking the quantities down to zero and then importing them with the corrected values would probably be easiest.
3 Views