Sage 100

I've been tasked with creating a VI job to import cash receipts and am new to using VI. Actually, fairly new to Sage, but I come with some relational database experience. I am having issues linking the AR_CashReceiptsDeposit and AR_CashReceiptsDetail…

Not sure if anyone else has experienced this, but it appears that if you add a UDF in Sage 100 2022 Premium, but only update it via the 'Pending Changes Summary', the UDF is created in the data dictionary, but is NOT added to the corresponding SQL table…

Hi, We want to import a sheet from a client that sends us a csv of monthly invoice info. Some lines on the csv need to be split into 2 and occasionally 3 lines, based on the data. I can parse the line fine, but is there a way to have multiple detail…

I set up a VI job to set paperless office settings for all of our customers so it would email their A/R Statement to a contact code (rather than the customer email). Now I'm trying to figure out how I can remove that contact code using a similar job …

I've been working on a VI Import job for PO receipt of goods, serialized items. I think I am close, but I am running into this error: T Record Invalid or Write Failed. I've scoured the net, Sage City, Knowledgebase for a solution but no luck. Does anyone…

Our AP / Inventory person yesterday ran into this issue...old transactions suddenly appearing the the Daily Transaction Register. She alerted me of the issue and I have searched here and KB but not finding any answers: Also odd that the 10-31-22 transaction…

How can I use an IF THEN ELSE statement in the Expression Builder when importing a job? I keep getting a syntax error. For my current example: I'm looking to import item shipping weights. I already have my import value assigned to Temp001 . So now I…

Is it possible to create either a Crystal report or VI export job to show a list of AP invoices that were adjusted over a certain period of time? I'm having trouble distinguishing between original invoices and adjustments when looking in DFDM, other than…

My client imports SO Invoices, and would like to calculate the quantity of one line based on the running total of the other lines, and then assign that quantity to the item line. Here's the scenario: 1. Accumulate the quantity of all the items that…

I just upgraded from Sage 2018 v6 to Sage 2022.1. My AR people are not able to run the AR Report now. The error message involves and error dealing with one customer. When I look at this customer, he has a lot of extraneous characters in his name. This…

need to import Quantity used in to work tickets. I have a VI Import to JT_Transaction that when run populated the JT_Transasction file. Seen in DFDM. However, it does not show in the work ticket; the exploded sales order nor does the quantity appear…

Working on Sage 100 v2016 and trying to figure out how to import cash receipts using one file when the file does not contain a Deposit Number. I don't believe I can use the 'NEXT' operation because my Cash Receipts Header/Detail import needs to use the…

I think I know the answer to this but want to confirm.. If we run a backup/copy of a company before closing all modules expect G/L then couple days later run another backup/copy of same company just for G/L module with the same backup/copy company name…

I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…

When I started with Sage, I took several classes online - Data File Structures, Crystal Reports, etc. I can't find any resellers that offer these programs anymore and Sage seems to only offer X3 classes. Yes, I see the YouTube offerings but I am looking…

Running Sage 100 v2018. Creating a VI import job where the field in the import file has a date format of YYYY-MM-DD. Unfortunately there isn't a date format option matching the dashes ( - ). Is there a perform or conditional expression I could use to…

We have a client that is using Sage 2020. They say that they had been able to export to Excel but suddenly they are unable to. I have checked their Excel and it is the 32 bit version. Any ideas on how to correct this? Thanks Sue

There are a few threads offering perform logic for VI jobs to prevent duplicate A/P invoices for older versions of Sage 100. Would anyone be willing to share any updated steps or perform logic for the latest version (Sage 100 2021)?

Hi Forum, Just did an upgrade from Sage 2016 to Sage 2021.2 Premium, We install Sage on a SQL database with MAS_XXX being updated thru SQL Mirroring (DSD) because the customer had internal tables already in it and instead to creating a fresh MAS_XXX…

I am trying to figure the best way/best practice method of displaying one of our vendors inventory within our Sage system. All the items are IIG matrix items and we receive the data with the quantities being tied to the UPC. I have all the UPC codes already…

Running Sage 100 v2018 and have a VI import that brings in records into AP Manual Check Entry. The client wants to suppress any invoices that are not in AP_OpenInvoice and be able to review the Import Log to see those invoices that were skipped. This…

Other users with other roles can export. Role Maintenance:Library Master:Miscellaneous tasks:Business Insights Reporter Export doesnt show in role maintenance either. Business Insights Report Import is enabled.

Running SAGE 100 v2018 and am exporting out of PO_PurchaseOrderDetail. Trying to figure out the correct syntax for a conditional statement where a TEMP field will either populate "OPEN' or "CLSD" depending on if QuantityOredered = QuantityInvoiced. If…

There are several orders in our system, of which both the Sales Order Entry UI and table field of PickingSheetPrinted indicates that the picking sheet has not been printed. However, I do find the paper version of picking sheets of those orders in the…

Could someone explain why the line key for line items doesn't change for the line when rearranging the lines in PO entry? Example; item#ABC on line 1 its line key=1 item#def on line 2 its line key=2 item#ghi on line 3 its line key=3 item#jkl on…