Browse By Tags

  • Sub Contract - Cost variance not creating or posting to GL

    Hi; Verision 6.5 patch level 36 We have set up subcontracting for purchasing; the provisional cost is calculating correctly and the receipt value to GL and stock is correct. However; if the average cost of the raw material changes during the contract…
  • Add method to obtain Stock Item Unit Cost

    FormerMember
    FormerMember
    When making adjustments through the SDK (negative adjustments) Sage will automatically set the unit cost based on the costing method used for the company. When querying these adjustments back through the SDK or API, the unit cost always comes back as…
  • Average cost calculation

    Client has a few items with really far out Average costs. Supposed to be $1 and shows $950 Average cost. The MRC is good and last cost is good. Is there a way to fix the average cost? There was an adjustment done a few months back that was in error…
  • Trying to create a report in SQL that pulls all costs for an item.

    I am trying to create a report that pulls all OE sales by month and includes standard cost, average cost, most recent cost, last cost, alt cost 1 and alt cost 2. I can't seem to find which table or view has all of these costs. It looks like they are…
  • Inventory cost problem

    1. Find below screenshot, for a particular item cost is booked while doing PO Receipt but when those items were sold it is not showing any cost for shipment entry under inventory out. 2. And for some items, it just suddenly takes some unrelated…
  • Hi, how do i resolve? I am getting this error when running an in process posting for costing(WIP Accounting interface)-Unbalanced journal legal

    Unbalanced Journal Legal KEY1=0911511MFG-000005 KEY2=~ KEY3=~ KEY4=~ KEY5=~ Last WIP : VCRTYP=10 VCRNUM=0911511MFG-000005 WIPSEQ=11 TXNTYP=15 MFGTRKNUM= MFGTRKLIN=0 End of log file error 12/01/15 13:34:16
  • Cost setup for FIFO Part number

    Hi, Pls. advise me how to setup the cost for FIFO parts ? e.g below is my bill of material Parent part is PART-01 - Valuation method is "STD" (Standard ) Component is COMP-01 - Valuation method is "FIF" (FIFO) Component is COMP-01 - Valuation…
  • Is there a way to get real-time variance if an independent timekeeping and payroll system is used? Can you get real-time variances if you are using the payroll module in MAS500?

    We are a manufacturing process whereby management and ownership would like real-time variances specific to Labor. However, hours worked and pay per hour are not recorded in MAS as a third party provider is used for the time keeping system and then another…
  • Standard Cost Issue...

    Hello, I am trying to build my standard costs in a way where I leverage the Bill or Materials to add non-inventory Items which I can cost at specific rates and re-direct through the GL Accounts to specific account. The purpose of this will be to be…
  • Understanding Cost Tiers

    Hi there. I often talk to our customers about inventory costing and thought many of you would find this document helpful when trying to figure out how the cost for an inventory transaction was determined. So here it is: A cost tier stores the cost…
  • Costing

    I have a client who leases space and provides food and beverage for events. She wants us to be able to provide reports that will show the profitability of specific events. So, we would need some way to specify the event in the expense line item, and we…