So I know I can use suitescript to create inventoryadjustment records as needed, but I've been having trouble generating the inventoryworksheet record type. My goal is to create a script that shouldn't need to be run more than once ( and maybe once a year just to be sure ), that will connect with our inventory management / POS system and true up all quantities on hand for all inventory items based on the external systems data. I could get this working using inventoryadjustment records as previously stated, but our financial department has a preference for the worksheet. Does anyone know of good resources I could look at for how to accomplish this?

... no kidding. It's not supported 👀

i have some ancient SS1 scripts generating a

binworksheet

i could dig up for you, idk how analogous it is to an

inventoryworksheet

Thanks, turns out the worksheet is mostly supposed to be used with CSV uploads. I was seeing if I could utilize it because my financial dept. wanted to see it that way. I'll have to let them know that they can have it their way if we still do things manually with CSV's, or we can find a decent automated solution using the other records type. They both accomplish the same goal (mostly).