Handling, Shipping & Clearance

you mean creating a service item for freight and handling?

The problem isn't with the items that we are buying from our suppliers..
the problem is the that needs to be added to the shipment which should alter the standard price of each item..
for example we receive our shipment by DHL.

how do we add the fees that DHL is charging to deliver a certain P.O

@joe
the best way i am aware of is used by oracle systems..
they have the normal GRN like in FA but they have an extra GR2 and GR3 for services like freight and clearance.
after that the sum of GR2 and GR3 which are connected to the GRN is distributed among the items of GRN.
this will update the landing cost with the shipment and clearance and whatever charges that was made for the shipment to get into inventory and that wont change the purchase price for reference.

@joe
thanks..
i'll try to help as much as possible.

Respect.

I would add to @Alaa concern. This problem also occurs in Imports. In Imports we are importing in USD but paying Custom Duty and other charges in Local Currency.

Since the supplier ledger needs to be updated with USD so the Item Cost is updated with only Purchase Price Converted in Local currency. and the other charges are not added to the item Cost.

One idea, but I haven't tried it out yet.

https://github.com/apmuthu/frontac24/pull/7 allows service costs to be wrapped into purchased item costs on a single P/O or direct invoice and offers three methods for the calculation.

Thus, using the example offered, each computer is $100 and 10 computers are ordered.   A Freight service item for $100 is added to the P/O, and using the Quantity method, the price of the computer is automatically recalculated to $110 and the service item is zeroed.

While this does not directly address the issue of wrapping in P/Os from multiple vendors, such as DHL, it may be possible to do this by leaving the P/O open until the DHL bill arrives:

1.  When the DHL bill comes in, add the freight to the original P/O, which is then incorporated into the item pricing as described above.

2.  Because now this overstates the amount payable to the vendor of the original P/O, when the P/O is invoiced, the Freight account must be added as a G/L item to the invoice using the negative amount of the DHL payment.

3.  The amount invoiced should now be correct for the original vendor.

4.  DHL is paid in the usual manner against the G/L Freight account.

5.  The net Freight expense is zero, because the negative amount on the invoice offsets the positive amount of the DHL payment.

Result: the cost of the DHL freight is captured in the item price and will be reflected in COGS when the item is sold.

The disadvantage of this approach is that the P/O had to remain open to wait for the DHL freight billing, which delays deliveries, and therefore may not be acceptable.

I wrote the pull request to operate on the P/O, but perhaps it would preferable for it to operate when the invoice is created, which should work because item prices are not firmed up in FA until then.  That would allow the delivery to go forward before the DHL freight bill was received.

@braathwate, I was trying your fork to test this feature. I am facing one problem. When I select a Service Item on PO or Invoice I can see a Drop Down under COGS column with 3 options. By Line Total, By Quantity, By Line Item.

Unfortunately I am not able to select any of these three options as the Ajax is taking back focus from this dropdown list.

No, not the Ajax is running on COGS menu rather it is running on the Price Before Tax as shown in image . When the focus shifts from Price Box to COGS menu the Ajax runs and bring the focus back to Price box.

I am sorry to bother you. Actually I was trying on my custom theme and in that theme I am using Select2 for drop down. In that theme the COGS dropdown is not retaining focus when I hit tab from Price before Tax. While it is working fine on default theme on the same installation with same data. I will try to fix it.

One thing I need to ask is that while we are importing goods from foreign supplier hence different currency. But the Local Expenses are in Local currency. Is this also handled in this Modification?

Anyway this is a very useful modification and very beautifully placed in the current UI.

Bundle of thanks.