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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Deborahza

    GL Consolidations

    Hi, Getting an error trying to import a GL Cons file: "Description: Import Options Invalid list choice put to field 'Import Opt. Flds from G/L Setup'." There are no optional fields on the accounts. Anybody seen this before? Sage 300 2016 PU5 Thanks in advance Debbie
  2. Deborahza

    PO's not showing on PO Action Report

    Hi, Had a client log a call saying 3 PO's were not showing on the Order Action report. Went to check in sample data and could sadly replicate it. If I printed by Purchase Order date - they all showed but if I changed it to Expected Arrival date - said PO's were not listed. The one did not have...
  3. Deborahza

    You do not have a licence to use this product on multicurrency databases

    Thanks Phil :) Will give it a try. Have a great weekend.
  4. Deborahza

    You do not have a licence to use this product on multicurrency databases

    The first one is for automatically putting AP Invoices on hold and the other is for a GL extract.
  5. Deborahza

    You do not have a licence to use this product on multicurrency databases

    Hi all, Have this issue when running a macro. Had it at two different clients with different versions of Sage 300. One is V6 and the other is 2012 (would need to confirm) and all use SQL. If they restart the server (using local install) or log off completely and log back in (RDP) it clears the...
  6. Deborahza

    Vendor Number Change

    Thanks :) Will give it a try
  7. Deborahza

    Vendor Number Change

    Hi, Having a problem combining vendors (Sage 300 2014 PU1) When you open vendor number change and select combine and then click on the down arrow to select the vendors I am having two issues: 1. It only lists the vendors up to "T" then when I click on the last "T" and click again it shows more...
  8. Deborahza

    Generic Line Data. Attempt to modify a different record than was retrieved

    Ticked and path is C:\Windows\RVSPY.LOG
  9. Deborahza

    Generic Line Data. Attempt to modify a different record than was retrieved

    RVSpy output not creating log. :( [89ac.7ff.3298] PO0335: PODEPR [00:18:30.57] Unload [89ac.7ff.3298] 9903 <== [00:18:30.59; t=95140;ovh=82198] {**ERROR**} Those are the last two lines. On the Day End screen, gives the dayend number 8492,1... but no other info. I can restore the back up but I...
  10. Deborahza

    Generic Line Data. Attempt to modify a different record than was retrieved

    Thanks Tuba. I did a SQL query and the only tables that had the receipt were PORCP H1/2/L/M/I So I deleted the lines and re-ran the day end process. It ran further and has created an AP batch but it does not complete. Description: Day End Processing could not process all transactions. I am busy...
  11. Deborahza

    Generic Line Data. Attempt to modify a different record than was retrieved

    Hi, I have a problem on day end. There are two receipts that have the same RCPLSEQ and in SQL I can find one in the PORCPM table and one in the POLINEZ. I need to delete the one (it's in the PORCPM table) so that the day end will run. What tables do I need to delete this Receipt out of? It has...
  12. Deborahza

    AR Invoice and sub reports

    If I do copy it into 5.6 and use it, get the same error
  13. Deborahza

    AR Invoice and sub reports

    No. It's the ARDINVO report in the 5.6 folder that has a sub report added. Ran a repair on the Accpac instead of re-installing and it still gives me the error on our server. Yet it works on my laptop through crystal and Accpac.
  14. Deborahza

    AR Invoice and sub reports

    I have tried running it on my laptop now and it works. So I am re-installing AR on the 5.6 test server and will see if that makes a difference.
  15. Deborahza

    AR Invoice and sub reports

    Ok I made a boo boo, it's 5.6 It's on the test server we are using to test the 5.6. upgrades and integrations to our fuel system. The main and sub report are using the same ODBC driver. We have tried running just the sub report with only the ARIBDO table and we still get the same error. TYIA Debbie
  16. Deborahza

    AR Invoice and sub reports

    It's MSSQL 2005 and A4W5.5 And using Crystal 11
  17. Deborahza

    AR Invoice and sub reports

    Hi, The ARDINVO report was modified to add optional fields on a sub report by a old colleague. Saved a copy, re-set the datasource locations on the main and sub report. When I run the report in crystal it brings back the invoices but when I run it through Accpac I get "The table 'ARIBDO' cannot...

Part and Inventory Search

Back
Top