Welcome, Guest. Please Login.
05/19/24 at 12:55:34
News:
Home Help Search Login


Pages: 1
Send Topic Print
Allocating 3rd Party Freight Bill (Read 1294 times)
Joyce U.
Browser
*


Barefoot on the
Beach

Posts: 7
Gender: female
Allocating 3rd Party Freight Bill
09/17/03 at 14:14:42
 
I have a 3rd party freight bill that I'd like to allocate to the cost of the product received.   My product received is on a purchase order to our vendor, but the freight is being charged by a freight company.
Any suggestions?
 
Thank You!
Back to top
 
 
  IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: Allocating 3rd Party Freight Bill
Reply #1 - 09/18/03 at 06:42:45
 
Charge the freight bill to the inventory GL account #.  Manually adjust the value of the part in question through IN-K
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
Joyce U.
Browser
*


Barefoot on the
Beach

Posts: 7
Gender: female
Re: Allocating 3rd Party Freight Bill
Reply #2 - 09/18/03 at 09:25:00
 
Thank you Karen!
Just further clarification, this will not cause an overstatement of inventory by charging the inventory account and then doing an average cost manual adjustment?
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Allocating 3rd Party Freight Bill
Reply #3 - 09/18/03 at 10:03:00
 
Karen is right, the GL Posting will occur only once when you enter tthe freight invoice.  Editing the Average Cost in IN-K will not make a GL posting.  You will need to run UT-K-G to get book value in line.
 
For future, you may want to use the Freight Percent in Inventory to automatically burden inventory for freight.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Allocating 3rd Party Freight Bill
Reply #4 - 09/18/03 at 14:17:22
 
Quote from Lynn_Pantic   on 09/18/03 at 10:03:00:
For future, you may want to use the Freight Percent in Inventory to automatically burden inventory for freight.

 
We have the same situation on a regular basis. I had checked into it when we started with DBA and decided I would expense the 3rd party freight to our COGS account.
 
However, it seems that this might work, but I'm a little confused about using freight percentage. Do I use the same GL account as the item Asset  (defined by class) for the "expense", or...?
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Allocating 3rd Party Freight Bill
Reply #5 - 09/18/03 at 15:51:30
 
There is a default account on the AD-A, Mfg Defaults screen for the "Absorbed Freight In".  It should be an expense account next to your Freight In Expense account and will carry a credit balance offsetting the debit in Freight In.  Posting will process as follows:
 
Establish (as an example) a 10% freight percentage in IN-B for an item.
 
PO-C for 100 each @ $1.
Program will add 10% to inventory value.  
Unit Cost in IN-A is $1.10
GL Posting will:
Debit Inventory $110
Credit PO/RNI $100  
Credit Absorbed Freight Account $10
 
Process Vendor Invice for $100, it contains no freight.
Debit PO/RNI $100
Credit AP $100
 
Receive third party freight bill for $12
Debit Freight In $12
Credit AP $12
 
Comparing the Freight In of $12 and the offsetting Absorbed Freight In of $10 indicates that the 10% value is not accurate.  If this fluctuation is large, consider adjusting the percentage in IN-B for future receipts.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: Allocating 3rd Party Freight Bill
Reply #6 - 09/22/03 at 05:26:02
 
Thank you. I think this will work pretty good.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1
Send Topic Print