Sage 100

I'm on Sage 100 Standard 2020 (v6.20.1.0). We create sales orders, and then after each sales order ships, invoices are imported into a SO_InvoiceHeader batch. When the batch is posted, all the sales orders are supposed to disappear from SO_SalesOrderHeader…

Hello, Sage 100... Why can't multiple people do journal entries at the same time or why can't we run any reports if someone is in the processing of posting a journal entry

A General Ledger account is missing for a division number 00.. I saw a posted solution on forum and did verified all GL accounts were correct under A/R Division maintenance. We know what line 2 on the PO is causing the problem just don't know how to fix…

In a test company our # of SO's is getting large and I would like to delete most of them. When I go to run the utility a message comes up that orders can't be deleted when S/O Invoice data entry is in progress. So, I am trying to delete the batches and…

Does anyone know if you create a memo in Sales Order does it carry through when invoiced? I wanted to use this to record order information regarding who released an order from credit. It is only useful if later once invoiced you can see the memo. Will…

I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…

Hi, I was trying to post 2 Credit Memos in Sales Order Invoice. When I process it, Sage says there was an error, would you like to see the error log? I clicked yes, and the error log shows Error Description and just lists the 2 credit memo numbers.…

Sage 100 2020 Premium (6.20.1) After deleting old users off a system, the GL drill down from Transaction tab "Updated By" is blank for the deleted users. The deleted user keys are listed in SY_UserHistory. Short of 'reactivating' the deleted users…

Is there a way that I can sort the items I invoice by category? We have been really busy here lately, and I'm trying to take some time off of the amount of time it takes for me to process an order. I manually input each order and I sort them by bottles…

Is there a way to pull up old AR Invoice Batches? Need to see who created a few old ones to track down some irregularities. Thanks Sage 100 Advanced 2018 Update 10

I've uploaded multiple Journal Entries from the VI. How can I post only 1 at a time? (in the example below, I am ready to post GJ-000005, but not GJ-000004 just yet) Will Sage 100 post whatever is in the queue even though the JE contains zero or has been…

I am using BOI to automatically create production entries in BOM in Sage100 ERP. I realize Sage100 ERP support is obsolete, but it is what our company still has and we plan to update in the next year. I have some code I threw together below for testing…

Hi, My company is currently importing journal entries to the General Journal Entry module by uploading a csv file through the General Ledger Exchange. I was wondering if there's a way to customize the settings so that Sage is the one assigning the journal…

I'm trying to recreate PO Receipt of Goods from history. I can't seem to import to a PO where 10 lines are lot distributed and 1 line is not. What field can i add to distinguish between them?

Hello all! I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…

Hello, We have been having issues with Sales Order Batch Authorization. Nothing errors out until the final step where accounting actually tries to process the credit cards .Here is the first, which I'm unfamiliar with: The second one, I have…

It seems like this would be possible, especially since there is an option in Shipping Setup Options to 'allow changes to backordered quantity on line', but I can't seem to find a way to zero the qty backordered column in Shipping Data Entry without it…

Hello, We deal with 100's of counterparts in retail in the US. Some sends us several purchase orders per week and we wanted to find a way to aggregate these orders and have one shipment instead of multiple so to save on shipping costs...and the environment…

Hello, We have a miscellaneous charge we add to certain customers sales order. I was just informed that although these are showing up on the Sales Order, the customer is not being billed for this. How would I go about ensuring that this miscellaneous…

Hello, During our end of day procedures we had the following error come up while trying to update the SO Journal: We had an average day of sales, and have had many days which had greater sales. However, the error says 'PROGRAM size too large', not…

Client is currently on Sage 100 2016. We are in the process of updating to 2018. Client has an import job for work order that I created many years ago. As I recall it was a particularly difficult import to create. It still works nicely and is used on…

Hi All. We are currently on Sage 100 Standard 2017 (version 5.40.1.0) We have a large number of invoices that we generate at the end of the day this could be from 1500 - 4000 invoices. We can run Daily Sales Reports/Updates sometimes during the…

Every now and then one of my locations has their internet drop when one of the stations is writing a sales order. When we log back in, the invoice gets distributed to all open batches across the company, and cannot be deleted or changed. It will not update…

I have been working on an import for a client to work order to enter time. The data I have has the work order number, the time, employee, and the step number always default to 10. However, the entry requires the WORK_CENTER and the OP_CODE which would…

I am currently using an import in VI that uses the GL Transactional Journal Header table. Currently when I run this the, GL Detail Report gives me a breakdown line by line of every entry hitting the liability account. Is there any way to make this summarize…