Hello Sage 100 Community,
I've been tasked with creating an Excel import sheet for Journal Entries. I've used the following layout:
Account No.
Debit
Credit
Posting Comment
Journal Comment
6570-00
500.00
0.00
Test comment…
New install bringing in JC Trans Detail seems to think all entries are change orders and change orders can only be Cost Type S (subcontractor). Errors on all transactions that are not Cost Type S.
Morning,
I am trying to create a conditional express for a VI export job, but don't seem to be able to figure out the formula. Can someone guide me on what it is I am doing wrong (if not all)?
{SY_SalesTaxClass29.TaxClass$} = "NT" then {Temp002…
I'm trying to create a VI Import job to bring in some general journal entries but can't seem to figure out to grab the next Entry No automatically like I can with Batch Numbers and Invoice Numbers. I can't get them to import properly without actually…
Have the following source file (CSV)
2 questions:
1 - I want to import the Invoice No and append "-CM". Is this possible?
2 - Importing the lines Distribution Amount from the Credit Column. How do I reverse the sign so it comes in as a negative…
Hi, I am attempting to export the JT_Template table to turn around and import the file in another company. The only field not coming through the export is the Text field from tab 6 of WT Template Maintenance. The field in the Data tab of the export says…
Hello everyone,
I received existing import job with defined perform logic
The import job contains Command "CREATE_ERRORLOG" on Failure.
Сan anyone tell me where I can find this error log?
Also, Is there a link where listed all available commands…
Running Sage 100c 2018
I had a job get stuck and attempted to unlock. In doing so, it now gives me the error that a file could not be found and an error #12
File VIWDEF.LIB
Is this an easy fix?
Thanks,
Ryan
I exported the AR_OpenInvoice file to Crystal to extract very old invoices and save to a .csv file.
I built a simple VI_Import to create CMs to write off the invoices. The import job validates on test but then fails when run with HS Record Invalid or…
Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?