Sage 100

Can anyone please help me in editing the on-hand quantity for this location in sage. Tried editing it from Item Inquiry but it is not working.

The total is displaying as zero in Invoice Data entry I've written the script for the extension amount as follows. Can you pls clarify which column should be used to store the total?

Hi Team, Can someone kindly help me with displaying the invoices in the customer maintenance section? It appears in the data entry for invoices but not in the section for customer maintenance.

I haven't seen a post from David Speck in a while. I received an e-mail a while back that the company he worked for was acquired by Blythco.

Hello all, I'm seeing an odd issue with an external BOI script to populate and post cash receipts entries. The short story is that automatic posting results in a duplicate bank rec deposit entry and leaves an orphaned deposit record in AR_CashReceiptsDeposit…

Hello, We use Sage 100 > DM2 which has some additional journals that are not available with the standard Sage 100 product and therefore are not options to auto-save in the Journal and Registers Maintenance module. Is it possible using a user-defined…

Does anyone know how to control the invoice date and update date to prevent for updating the batch, until both are the same? This relates to all modules SO,PO, AR, AP, IM. If anyone knows how to custom script on how to handle this matter? thanks.

Hi All, I have placed an order for a course on Sage university but the system is not allowing me make the payment. Hence, we reached sales customer service via email and they reset the same and asked us to try and purchase the course again to redirect…

Hi, I purchased the above mentioned course on Sage university but I was not able to access the material as the payment was pending. Also, I got a auto mail from sage informing that one of their sales person will contact us for payment part, but I…

Hi Forum, We are getting an error 200 trying to create "AR_CustomerCrditCard_bus" object The customer uses Paya to pre-auth credit cards and for whatever reason it is not letting us create the object. This same code worked in Sage 2016. Upgrade…

Hi all, I was searching around and was not able to find issue that would provide me a hint on the problem I'm currently facing and was hoping to request some help from the community. I'm getting the error of.. A batch number is not set up here's the…

Hi, A few days ago I had a Post that I was lucky enough to get help with. After getting some feedback from some of our shipping department, they let me know that even if they go in and change the Ship Date in Sales Order Entry, the message box will…

When opening a Sales Order # in Shipping Data Entry, I'd like there to be a message box if today's date is past the ship date of the order. I grabbed this code off of a previous question I asked in this forum and figured I could use most of it for my…

The current period is 11-2021, but when I tested to change the accounting date to 1/5/2022, the box message said 1/5/2022 does not fall within the current and one future period for the module (10/1/2021 to 11/30/2021). I expect the current and one future…

We are running Sage 100 2019 (6.10.4.0)(Payroll Version 2.20.0.0). I hope someone has an idea how to correct this because I'm at a loss. We have one employee that all of a sudden is not having FICA calculated on their check. This person is not even…

Does anyone know how to vouch an invoice where the associated standard costs includes freight from a third party? The idea would be avoid a large and inaccurate variance. Thanks

Hello Everyone, I am looking to Automatically update invoices wither certain criterias, any idea on how to do this? I am looking to have the invoices with certain Customer Divisions that have a tracking number upated automatically each day. All our…

How do I reverse a prepayment in Accounts Receivable?

On occasion we need to move one or more cash receipts entries out of the existing batch, into its own batch. Currently the only way I know to do this is to view the existing entry, open a new batch and manually recreate the entry in the new batch, before…

Hi Forum, Is there a way to Update CI_ITEM Average Cost ?... I have a BOI script that is trying to update the cost and i get the message below... The cost it is in fact "Read Only", is there a way to change it so i can update it ? Regards…

I have a c# program that automates inputting sales order invoices based on provided xml data. Currently I am setting the batch no and then using, successCheck(headerObject, (int)headerObject.InvokeMethod("nSetKey", headerInfo["InvoiceNo$"]), "SetKey…

Experts, I am working on a script that modifies the comment on a batch, sets it to private, and eventually attempts to post batches. I am getting the following error message when attempting to do the nSelectBatch on the SO_SalesJournal_upd object: …

Hi Forum, I am getting an error 0 in Method SETKEYVALUE trying to set the key for Sales Order Lines. Below is the code i have. I can read the key of the Sales Order Header but i cannot read the Lines. 'Get Sales Order Header retVal = o.nSetKeyValue…

I tried the link Sage sent me for the STAC 2021 virtual conference happening tomorrow. https://sage.vfairs.com I tried going to the vfairs.com site to see if they offer the client software to download but no luck. This is the message I received…

Experts, I have an issue with automating invoice emails through Paperless from the AR Invoice History Printing report. The code below works fine in my test environment but fails (without an error) in the target environment. My test environment is…