If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information:
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply).
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information:
Yes, you can update the COGSAccountRefFullName values of the ItemInventory and ItemInventoryAssemblyLine tables directly using QODBC. But IncomeAccountRefFullName can't be updated.
Will it have retro-active effect on the old transactions in QB? Like in the attached screenshot, we wanted to say 'YES' , so that even old transactions will be affected. We have one year worth of data on this QB file.
As i was trying to update the Items' account assignments.. i noticed that u mentioned in your previous reply
"you can update the COGSAccountRefFullName, IncomeAccountRefFullName values of the ItemInventory and ItemInventoryAssemblyLine tables directly using QODBC."
Should'nt I be updating COGSAccountRefListID and IncomeAccountRefFullName instead?
I have updated the QB7 Ent - Manufacturing Ed with the latest patch R11P, both on the server and client. Still I'm getting same results with sp_columns iteminventory.