Forum pracy nad projektem wskrzeszenia The Forge Forum Index Forum pracy nad projektem wskrzeszenia The Forge

 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   GalleriesGalleries   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Free Packing Slip Template for Excel

 
Post new topic   Reply to topic    Forum pracy nad projektem wskrzeszenia The Forge Forum Index -> Forum
View previous topic :: View next topic  
Author Message
sdvcxvdsf




Joined: 30 Mar 2011
Posts: 1
Read: 0 topics

Location: England

PostPosted: Wed 6:00, 13 Apr 2011    Post subject: Free Packing Slip Template for Excel

Using the packing slip template is pretty intuitive, but there are a couple things you should be aware of. First, the date in the upper right uses the =TODAY() function which will always display the current date. If you want to save an archival copy of your packing slip,Packaging machine, you may want to manually enter the date so that it doesn't change when you open the file again. Second, you can insert rows for more items, but afterwards you should check the Totals to make sure they reference the correct cells.
Comments: The comments block is for including notes to your customer. Instead of making one large cell for the comment block like many other packing slip templates, each line is a separate cell so you can easily add/delete common comments. For example, if you wanted a backorder note to show up automatically when the shipping quantity is less than the order quantity you could use the following formula:
=IF(G38<F38,"Backordered items will ship as they become available","")
Tip: Outside of the printing area, you could list some of the common comments that you use so that you can simply copy/paste the appropriate notes into the comments block.


The post has been approved 0 times
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    Forum pracy nad projektem wskrzeszenia The Forge Forum Index -> Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

fora.pl - załóż własne forum dyskusyjne za darmo
Powered by phpBB © 2001, 2005 phpBB Group
Regulamin