Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem importing A/P invoices with V/I 1
- Thread starter emaher
- Start date
-
1
- #2
Subject:
Batch numbers are not created when importing into data entry files such as AP.INVOICE (AP5) or AR.INVOICE (AR7).
Possible Resolutions:
The Batch number is created by executing the perform logic in the 'Record' tab of the import job
1. Verify record type is defined correctly in the 'Records' tab
2. Verify that the record contains Perform Logic. To verify that the Perform Logic exists, double-click the record in the 'Record' tab, and click 'Perform'. A command should appear in the command list. If a command does not exist or is incorrect, click the lookup for the command and select the appropriate command for the file being imported. For example, if importing into AR.INVOICE, select the command for AR.INVOICE
Note: It may be necessary to remove the record from the 'Records' tab, then reselect the record, redefine and add back the Perform Logic command. The Perform Logic should repopulate automatically if the record is selected from the lookup.
How to verify the record perform logic is correct when importing into Sage MAS 90 or Sage MAS 200
Entry Type: Informational
Product: Sage MAS 90 ERP, Sage MAS 200 ERP, Sage MAS 200 ERP - SQL Server Edition
Application: Visual Integrator
Version Reported: 3.70
Subject:
How to verify the record perform logic is correct when importing into Sage MAS 90 or Sage MAS 200.
Possible Resolution:
To confirm whether or not the record should have perform, on the 'Records' tab select the 'Record Type', click on the 'Perform' button and use the lookup to see if there is 'Perform' logic.
Note: On versions 3.60 and below, create a new job and check the perform on the records tab for the new job created.
Note: Check the "Perform On" field to determine if the record perform should be a "Before Write" or an "After Write" command.
The following list of standard perform commands can be entered at the Command field on the Records Perform Logic dialog box. Choosing the Perform button on the Record Properties dialog box in Import Job Maintenance accesses the Records Perform Logic dialog box.
Dictionary Name Command
AP.INVOICE ..\AP\APWVIP;AP_INVOICE
AP.MANCHK ..\AP\APWVIP;AP_MANCHK
AP.MANCHKS ..\AP\APWVIP;AP_MANCHK
AP.VENMEMO ..\VI\VIWLIB;PROCESS_MEM
Batch numbers are not created when importing into data entry files such as AP.INVOICE (AP5) or AR.INVOICE (AR7).
Possible Resolutions:
The Batch number is created by executing the perform logic in the 'Record' tab of the import job
1. Verify record type is defined correctly in the 'Records' tab
2. Verify that the record contains Perform Logic. To verify that the Perform Logic exists, double-click the record in the 'Record' tab, and click 'Perform'. A command should appear in the command list. If a command does not exist or is incorrect, click the lookup for the command and select the appropriate command for the file being imported. For example, if importing into AR.INVOICE, select the command for AR.INVOICE
Note: It may be necessary to remove the record from the 'Records' tab, then reselect the record, redefine and add back the Perform Logic command. The Perform Logic should repopulate automatically if the record is selected from the lookup.
How to verify the record perform logic is correct when importing into Sage MAS 90 or Sage MAS 200
Entry Type: Informational
Product: Sage MAS 90 ERP, Sage MAS 200 ERP, Sage MAS 200 ERP - SQL Server Edition
Application: Visual Integrator
Version Reported: 3.70
Subject:
How to verify the record perform logic is correct when importing into Sage MAS 90 or Sage MAS 200.
Possible Resolution:
To confirm whether or not the record should have perform, on the 'Records' tab select the 'Record Type', click on the 'Perform' button and use the lookup to see if there is 'Perform' logic.
Note: On versions 3.60 and below, create a new job and check the perform on the records tab for the new job created.
Note: Check the "Perform On" field to determine if the record perform should be a "Before Write" or an "After Write" command.
The following list of standard perform commands can be entered at the Command field on the Records Perform Logic dialog box. Choosing the Perform button on the Record Properties dialog box in Import Job Maintenance accesses the Records Perform Logic dialog box.
Dictionary Name Command
AP.INVOICE ..\AP\APWVIP;AP_INVOICE
AP.MANCHK ..\AP\APWVIP;AP_MANCHK
AP.MANCHKS ..\AP\APWVIP;AP_MANCHK
AP.VENMEMO ..\VI\VIWLIB;PROCESS_MEM
- Thread starter
- #3
Thank you for your informative post. On the Records tab, I have "Gl/Jc Line Type" which has perform only logic containing "..\AP\APWVIP;AP_INVOICE". I've tried adding this routine for both line types. Still no luck. What exactly does this routine do? Do I need to include a batch number among the imported fields, or will one be automatically generated?
On a side note: I thought that if I created a batch with the number I specified in the import, that this might fix the problem, but the invoices still don't show up.
On a side note: I thought that if I created a batch with the number I specified in the import, that this might fix the problem, but the invoices still don't show up.
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question