Transit Items + HQ


J

Julien Bonnier

Hi all!

We are using rms 1.3.10.10
I'm trying to make a Report for the Items in Transit.

The Items in transit are the items that we sent to a store wich they did not
received yet.

I don't know where to get this information I tought it was the committed
items but I made a PO with only one item and it doesn't appear to be
committed.

So anybody who knows where to find this info in the SQL DB (table/field),
please let me know.

Thanks in advance.

J.B.
 
Ad

Advertisements

J

Julien Bonnier

If you don't know where to get it in the db, maybe you can tell me where to
get it in the manager ... ?
 
G

Glenn Adams [MVP - Retail Mgmt]

Look at the interstore transfer report in HQ. If this won't get you
exactly what you need, it should get you close.
 
G

GregDxb

Let me try if I get it right--> transit items are ON ORDER items ??? or if
not--> how you make it, in a way you know it is a transit item? what menu ?

you'll get information ON ORDER qty when the purchase order is not yet
receive and commited..basically...it was save only...

then when you check in your item..in inventory tab..you'll get the no. of
pcs ON ORDER ... i hope this is right :)

if yes...you'' get this information in PO/POentry table with status open....

let me know if it is wrong :)
 
G

GregDxb

Placement status: Whether the purchase order has been issued or not.

try pressing F1 for help...there you'll find out the answer of some of your
questions. :)
 
Ad

Advertisements

J

Jason

Haha. The RMS documentation blows. That's why prople come here first. F1 us
useless.
 
J

Julien Bonnier

Yeah your right... customer source is way much better than the RMS help
file, but sometimes it's still hard to find the answer quickly.

thanks anyway.

Julien
 
J

Julien Bonnier

I figured out how to get the transit items from POs.

But now I need the transit for interstores transfers.

Should I look in the tables PurchaseOrder/PurchaseOrderEntry
or
in the table InventoryTransferLog

Thanks for your help

Julien
 
J

Jeff @ Check Point Software

Julien,

Transfers are just POs between stores

PurchaseOrder.POType

0 = Purchase Order
1 = Purchase Order generated by HQ
2 = Transfer In
3 = Transfer Out
4 = Transfer In created by HQ
5 = Transfer Out created by HQ


InventoryTransferLog = how/why products changed qty

--

Jeff
Check Point Software

=====================================================

You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
see and download the file attachment(s). If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=====================================================

I figured out how to get the transit items from POs.

But now I need the transit for interstores transfers.

Should I look in the tables PurchaseOrder/PurchaseOrderEntry
or
in the table InventoryTransferLog

Thanks for your help

Julien
 
Ad

Advertisements

J

Julien Bonnier

Thanks man.

Now I understand better how the system works.
I wasn't sure what was the InventoryTransferLog for.

Thanks again

Julien
Julien,

Transfers are just POs between stores

PurchaseOrder.POType

0 = Purchase Order
1 = Purchase Order generated by HQ
2 = Transfer In
3 = Transfer Out
4 = Transfer In created by HQ
5 = Transfer Out created by HQ


InventoryTransferLog = how/why products changed qty

--

Jeff
Check Point Software

=====================================================

You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
see and download the file attachment(s). If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=====================================================

I figured out how to get the transit items from POs.

But now I need the transit for interstores transfers.

Should I look in the tables PurchaseOrder/PurchaseOrderEntry
or
in the table InventoryTransferLog

Thanks for your help

Julien
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top