What specific question(s) do you have?
# accountingm
mkachline
03/07/2017, 5:49 PMWhat specific question(s) do you have?
m
mkmulkey
03/07/2017, 6:27 PMmkachline: I couldn't get a solid understanding of when the cost of sales adjustments appears in other random transactions based on backdating.
mkmulkey
03/07/2017, 6:28 PMcurrent scenario - i just went through a heck of a month where I've been creating backdated inventory adjustments and fulfillments and I see the cost of sales adjustments gl line showing up in some of them but I can't tell my accountants exactly why.
mkmulkey
03/07/2017, 6:29 PMso I guess my first question is - does this happen to augment already created fulfillments that occured after the transaction I created.
mkmulkey
03/07/2017, 6:29 PMsecond question: do the existing fulfillments not get updated during the cogs recalculation process.
mkmulkey
03/07/2017, 6:30 PMthird: is there any way to easily identify which fulfillments that cost of sales gl line on the inventory adjustment should be applied to. And is it definitely attributable to only fulfillments.
mkmulkey
03/07/2017, 6:31 PMthat's a good start.
m
mkachline
03/07/2017, 6:32 PMI honestly cannot give an educated answer as to backdating. I recall reading in Netsuite's help that they strongly recommend against backdating inventory adjustments for this reason; and thus, I have been working primarily in the realm of adjusting from "today forward" and using journals to fix any past COGs discrepancies.
mkachline
03/07/2017, 6:32 PMOne question back to you... Are you using FIFO or average cost for COGS?
mkachline
03/07/2017, 6:32 PMI ask because, I recall reading that the inventory adjustments basically assume you are using average cost.
mkachline
03/07/2017, 6:32 PMI'd have to dig up the NS help page, if you want more info on that.
m
mkmulkey
03/07/2017, 6:36 PMugh.
mkmulkey
03/07/2017, 6:37 PMi can't imagine having to journal all the mess I just dealt with.
mkmulkey
03/07/2017, 6:37 PMi am pretty certain that the backdating is causing it
mkmulkey
03/07/2017, 6:37 PMwe are using avg cost.
m
mkachline
03/07/2017, 6:45 PMI don't know if I can help much from this point forward. I can say, I would not be surprised if you are seeing previous item fulfillments "change" their GL impact based on back-dated inventory adjustments.
mkachline
03/07/2017, 6:46 PMAgain, we took the approach of "stop the bleeding" (by doing inventory worksheets from today), and then a one-shot JE to get past-COGs values corrected (with a decent amount of spreadsheet work coupled thereof.)
m
mkmulkey
03/07/2017, 8:12 PMugh. thanks for the input. appreciate it.