Warehouse setup help

[emre]

That does not counts them as purchase. Reports configured to list all transactions as purchases. For example you can configure it to something like…

[Purchases by Group:1, 1]
{REPORT INVENTORY TRANSACTION DETAILS:T.ItemGroup,T.TotalPrice.Sum:(ITT=Purchase Transaction Type)}
>Total|{REPORT INVENTORY TRANSACTION DETAILS:T.TotalPrice.Sum:(ITT=Purchase Transaction Type)}

[Purchases:2, 1,1, 1]
{REPORT INVENTORY TRANSACTION DETAILS:T.Name,T.Quantity.Sum,T.Unit,[T.TotalPrice.Sum]/[T.Quantity.Sum]:(ITT=Purchase Transaction Type)}

[Your Custom Transaction Type:2,1,1, 1,1, 1]
>Name|Source|Target|Quantity|Unit|Amount
{REPORT INVENTORY TRANSACTION DETAILS:T.Name,T.Source,T.Target,T.Quantity.Sum,T.Unit,[T.TotalPrice.Sum]/[T.Quantity.Sum]:(ITT=Your Custom Transaction Type)}

Change Your Custom Transaction Type parts with your type.

PS: For simplicity warehouse screen displays all + inventory as purchase and all - inventory as consumption. You can differ them in reports.

---

In case you need here are all possible {REPORT INVENTORY TRANSACTION DETAILS} fields.

T.TransactionType
T.Name
T.Date
T.Time
T.Source
T.Target
T.ItemGroup
T.AccountName

[a.samy]

Whats is inventory fields like

@emre

In case you need here are all possible {REPORT INVENTORY TRANSACTION DETAILS} fields.

T.TransactionTypeT.NameT.DateT.TimeT.SourceT.TargetT.ItemGroupT.AccountName

[emre]

Sorry couldn’t understand your question.

[a.samy]

{report inventory} fields

[Jesse]

What do you want to know about them? Look here for Custom Report tag usage tutorials.
http://www.sambapos.com/wiki/doku.php?id=custom_reporting_tags

[emre]

OH OK got it. {REPORT INVENTORY} does not have fields. It is a hard coded report. It only supports inventory item name so {REPORT INVENTORY:Meat} will return actual inventory for meat.

You can take a look to {REPORT CONSUMPTION DETAILS} tag.

Daily inventory count!

You can report End of Day records by using {REPORT CONSUMPTION DETAILS:X} reporting tag. These are the available fields for that tag C.StartDate C.EndDate C.Name C.Unit C.Inventory C.Warehouse C.Added C.Removed C.Consumption C.PhysicalInventory C.Cost You can use Data Export feature to export any custom report to Excel. You can find some samples here.

[somilmittal]

How do I sort the INVENTORY TRANSACTION by Warehouse Type?

The code below does not seem to work:

@{REPORT INVENTORY TRANSACTION DETAILS:T.AccountName.asc,T.Quantity.Sum::{0}:,}
[Inventory Purchase by Warehouse $1: 2, 3, 3, 3, 7, 2, 1, 2, 2]
{REPORT INVENTORY TRANSACTION DETAILS:D.Id,T.Date,D.Description,T.ItemGroup,T.Name,T.Unit,T.Quantity,[T.TotalPrice]/[T.Quantity],T.AccountName=$1}
>|||||||Total|{REPORT INVENTORY TRANSACTION DETAILS:T.TotalPrice.sum:T.AccountName=$1}

[emre]

Try including T.Target to get the target warehouse name.

[Dan]

Hi Emre. How do I transfer items from one warehouse to another. For example I have a bar but I keep stock in a certain warehouse named stores 1. So when the bar requests for items. The person in charge of store 1 issues the items. Therefore I want to have a report showing the stock that is in stores 1 and also be able to see the bar inventory. Thanks

[Veysel]

Hello Dan,

Could you please review the steps in the document?

https://kb.sambapos.com/en/4-16-how-to-configure-product-based-warehouse-tracking/

[Memo]

Here’s what I have from an old db. It should work for you. You can specify source and target warehouses when transferring inventory.

Inventory transaction type:

Inventory document type:

the move in action - I can’t recall if the cost is populated automatically so you’ll want to test before deploying:

[Dan]

Okay. Than you for the response. I have one more question. I have tried setting up use of points from Emre tutorial of v4 but I can’t figure out why why I do all the steps I don’t get the “use points” button like you see in his tutorial

[Dan]

Thanks you. Where can I find the report to view the transactions for this and inventory balances. Thanks

[Memo]

There’s a default inventory report that is supplied.

Here is what I used for transfers. This was from when I understood even less of the reporting features than I do now (which isn’t much) so this report must have been scraped from the forum. Perhaps it’ll show what you need.

[Purchases by Group:1, 1]
{REPORT INVENTORY TRANSACTION DETAILS:T.ItemGroup,T.TotalPrice.Sum}
>Total|{REPORT INVENTORY TRANSACTION DETAILS:T.TotalPrice.Sum}

[Transaction Entries by Warehouse:3, 2, 2, 2, 1, 1, 1]
@{REPORT CONSUMPTION DETAILS:C.Warehouse.asc::{0}:,}

>>Item|Purchased|Transfers|Result|Unit|Unit Cost|Total Cost
>>$1
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.Added.sum,C.Removed.sum,[C.Added.sum]-[C.Removed.sum],C.Unit,C.Cost.sum,[C.Cost.sum]*[C.Added.sum]:C.Added>0 and (PCW=$1) or C.Removed>0 and (PCW=$1)}