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: *

  • Users: kdien
  • 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

    Well that's kinda bizarre... so basically Sage just expects all users to manage the macros and custom reports themselves. Then if we reorganize and move the macros, it will be a pain to update the users' shortcuts. Any tips or tricks to help ease the process are greatly appreciated!
  4. 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...
  5. kdien

    Insert record in SQL Server

    We have over 40 databases on different servers, and some servers are in remote locations where connection is not great. Anyway, the system database was the key. There is another CSCRT table in the system DB. Thanks!
  6. 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...
  7. kdien

    How does Sage 300 do FIFO?

    OK this may be a long shot but is there a way to query an item in inventory (joining different tables) to get how many on hand and what makes up that amount? For example: Item ABC, 50 on hand total $5200, made up of: - 20 at $100 from RCP100 - 20 at $105 from RCP101 - 10 at $110 from RCP102
  8. kdien

    How does Sage 300 do FIFO?

    So whenever the inventory comes out (shipment, transfer from, receipt return, etc.) the system always checks and uses the offset bucket in ICILOC first? Or are there exceptions depending on the type of IC transactions?
  9. 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...
  10. kdien

    PO Receipt -> Invoice -> PO Posting Journals

    I checked the working ones and my test ones as well. They all show on the PO Invoice Posting Journal, either as the difference or just O if there's no difference. And there's no third-party application for this process. I figured this must be a bug since the only scenario where it doesn't show...
  11. kdien

    PO Receipt -> Invoice -> PO Posting Journals

    Yes I did multiple tests in our test database and anytime I invoice a receipt and change both the quantity and unit cost that results in the same extended amount (like RCP2), that line won't show up in the PO Invoice Posting Journal. Any other case (invoice same as receipt, change just quantity...
  12. 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...
  13. 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