Sage 50 US

I am using sage 50 and the way that I import is —> file—> select import/export —> inventory—> inventory item list where I’m trying to create my own template in csv in order to import item/inventory however it doesn’t go through which I believed the template…

Is there a way to upload an Inventory List into Sage 50? I have around 70 items that would be a million times easier to upload once, in lieu of keying them in individually. I have searched the Sage Knowledge Database, but cannot find any articles…

For the past several weeks I've been trying to import my old Peachtree 2009 data into Sage 50 Premium 2021 and everything has been smooth until I import the BOMList Journal and Assembly Journal . I've followed the import/export instructions step by step…

Hi, Inventory count on some items have gone to zero, like they disappeared from the database. There haven't been any activity on these items to explain this. I attached a inventory unit activity reports on one these items as an example. Has anybody…

My file sizes are past the quantum limits and I’m starting to get errors, so I’m exploring options. I’m at 300kb quantum recommends 250 max database size 1 Will the Quantum database sizes be expanded anytime soon? Maybe an enhanced version of Quantum…

Here is the field description for the "unit cost" field: Numeric (Real) - Unit cost for the line of distribution; it gets ignored for negative inventory adjustments, but gets used for positive inventory adjustments. ( Note: If this field is not included…

When I tried to build something in the assembly it showed a -1 quantity but when I look at the inventory it shows 0 quantity. I noticed this in several "assembly" items & it started about a week ago. Will running an integrity check clear this up? If…

Can someone provide a general SQL script/statement that I can use to extra basic inventory data from the Sage 50 Accounting (2016) database? All I really need are things like the part number/Item ID, description, Active/Inactive, and price levels (price…

What is the procedure to accurately import to Sage 50 new pricing on inventory items through an Excel spreadsheet? Specifically I am having difficulty in locating the file to import from, does it need to be saved as a certain type of file?