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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: kdien
  • Content: Threads
  • Order by date
  1. kdien

    AR Invoice Reversal

    Sage 300 2014 (62A) Is there an easy way to reverse a posted AR Invoice? Our users create credit note but still very manually and we usually have very big invoices with numerous lines. Even if there is a way to have a credit note automatically filled out from an existing invoice, it would help a...
  2. kdien

    PO Error

    Sage 300 2014 (62A) We have an old un-receipted PO that we need to close, either by changing its Quantity Outstanding to 0 or doing a 0 receipt and still marking it as completed. The line is for a non-stock item which may have been a stock item when the PO was created. When we try closing the...
  3. kdien

    Accpac Users Profile

    We are currently on Sage 300 2014 (62A) and are looking for a way to clean up and reorganize all the custom macros and reports. Is there any way to "see" from an administrator's point of view which custom macros and reports shortcuts as well as their path that each user has? I figured it could...
  4. kdien

    Insert record in SQL Server

    Sage 300 2014 (62A) We need to add a new currency rate type for several databases. We have a script to deploy an SQL script to all of our databases. So I tried to make that SQL script an Insert statement to the CSCRT table. Running the INSERT statement on a test database did insert the record...
  5. kdien

    How does Sage 300 do FIFO?

    We are running Sage 300 2014 (62A) and have been trying to work out how Sage deals with FIFO. Specifically, how does it determine which item (at which cost) to cost first when consumed? It would help tremendously if someone could help with the logic behind the whole thing, especially how to link...
  6. kdien

    Multiple Internal Issues on a Single Requisition

    We are using Internal Issues 62A and our users notice that fairly often, when they run Create Issues from Reqs, some items on the same Req will create multiple II's, and other times just one II. I looked into these II's and so far I could not make any connection between those. They seem random...
  7. kdien

    PO Receipt -> Invoice -> PO Posting Journals

    We have 2 PO Receipts, RCP1 and RCP2. One PO Invoice was done on both receipts (checked off Multiple Receipts) but: - RCP1: invoiced exactly the same with the rcp - RCP2: received 2 items @ $100, but invoiced 1 item @ $200, Fully Invoiced marked Yes I queried from table POINVAH / POINVAL to get...

Part and Inventory Search

Back
Top