Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject", "PO_PurchaseOrder_bus", oSS.GetObject())))
Could any one of you suggest, which dll or nuget to be used for this dispatch object.
We are using the below object management…
I'm not finding a way to import several Bill Numbers into this report's parameters.
Can you help me? It seems like i should be able to do this, however i'm not finding the right path yet. VI doesn't offer it and i'm having trouble finding clues to help…
Trying to update file names in the PDF_JournalPDFLog. Identified the Records but need to know what table I need to modify. Through VI, the table is not available.
Suggestions?
We are currently exploring usage of the Sage100.ObjectManagement NuGet package (.NET 6 FYI).
I can create AR_InvoiceHeader and AR_InvoiceDetail line items.
Preface: Already have an instance of MasSession that is all well and good (authorized and functions…
Hi Forum,
I am using .nCopyLinesFromSalesOrder(soOrder) to bring in all lines from the Sales Order into Shipping Invoice data entry and every order I import is duplicating the lines.
Any advice on this will be greatly appreciated.
Regards,
Ma…
Hi Forum,
I've been trying to import Cash Receipts via a BOI script and i am going nowhere.
Once i was able to import the lines but they came in with no AmountPosted.
Then i changed the script to find the invoice Lines and all of a sudden, no…
Running Sage 100 v2018 and am trying to create a VI import where one of the numeric fields being imported needs to have a $0.10 markup (i.e. if the field is populated with $2.35, the import should add .10 so the record would import the price as $2.45…
I have built an order importer that automatically creates sales orders based off of an EDI file from our customers. It works great. We are currently upgrading Sage 100 to include Production Management Plus and I want to be able to add in the ability to…
Hello not sure if this is the right place to ask this question but I'm looking to see if there is a table that hold records for the Purchases Clearing report..
Hi Forum,
We have a script that we use to import sales orders from a website. It has been working but we upgraded Sage 2016 to Sage 2021.2 Premium and now the BOI script is failing.
First, we had an issue with Tax Schedule is required message and…
Client running Sage 100 v2018. Trying to export purchase order information based on two select criteria that is outside standard fields. I'm able to create a Perform for the individual selections and when I add one of the two perform functions to the…
I am working on an import that is related to the following thread; https://www.sagecity.com/us/sage100_erp/f/sage-100-business-object-interface/177980/how-to-run-visual-integrator-from-bat-file .
When I go to test the PO_Header import I keep getting…
When exporting payment history for AP I am only getting a few years information. If I run a report I can see the system has 20 years worth of data but its only giving me 2+ years which is more like just the time frame for viewing in the system. I tried…
Running Sage 100 v2018. Created a VI import into AP_InvoiceHeader/Detail in order to populate invoices into AP Invoice Entry. I have a Perform that checks to see if there are duplicates in the AP_InvoiceHistoryHeader table:
------------------------…
I'm writing a BOI script to create Inventory Adjustment Transactions. I want to use the next available entry number so I have the GetNextEntryNo(refNo$) function in my script. What I can't figure out is what the "refNo$" needs to be. Does anyone have…
Need to clean up inventory alias.
My first attemp is adding another alias
I need to replace the alias with the alias in the import file
If I need to deete aliases first before I import, how do I delete without going into each alias?
I'm trying to create a job to change dates for Work orders. Some WO through errors like this when the Revision Code has any letters. Some of our revisions are just numbers like the ### but some do have some letters which are allowed in the Bill of Materials…
Hi Forum,
When importing Invoices in Sage i am getting the message.. "
You cannot use a credit card or ACH payment when credit card of ACH payment type is not set up"
The customer payment type is "CHECK", the process continues with no problem. …
We are exporting Sales Orders to a distribution center for shipping. I have created 2 UDFs on the SO_SalesOrderHeader table. Once the export file is done, I have a script that reads through it and is trying to update the 2 header UDFs. When I go to save…