+ Reply to Thread
Results 1 to 10 of 10

Inventory and Invoice Template : Broken Fields and Modifications Required

  1. #1
    Registered User
    Join Date
    09-24-2012
    Location
    Lagos
    MS-Off Ver
    Excel 2010
    Posts
    12

    Post Inventory and Invoice Template : Broken Fields and Modifications Required

    Good day, I am developing an Bar Code Inventory + invoice Template Excel sheet.
    I need help in fixing some broken data/cell connection which happened due tweaking an existing Bar Code inventory sheet, and also effect some desired modifications.
    Listed below are the details:
    FIXING REQUIRED
    1. The DESCRIPTION and PRICE Field (Column C and N of Sheet 1) not populating in the form field of ADD/UPDATE RECORDS & LOOKUP EXISTING RECORDS when the “Manage Inventory” button is pressed on scanning or inserting a Barcode data (Column A of Sheet 1)
    2. The DESCRIPTION Field (Column B of Sheet 2) is not populating the Sheet 2 after an update is carried out on any of the Quantity in Sheet 1. [Sheet 2 is for logging Inventory Activities]

    MODIFICATIONS
    1. Searchable dropdown list to automatically populate Customer information and products (Yellow Field) on the INVOICE sheet using their name [Solved]
    2. Print Preview the Invoice prior to printing using a Button
    3. Print the Invoice Using a Button
    4. Automatically log the Invoice and other customer parameters on PREVIOUS ORDER HISTORY Sheet upon Printing
    5. Generation of PDF of the invoice using concatenated Invoice Number and Customer Name as File name to a folder in the C:\ drive of the computer
    6. Ability to automatically send the PDF generated by email to the Client using the email in “F16” of the INVOICE Sheet. If PDF file does not exist, A message box should pop up to warn user that invoice for the order number and customer name does not exist.
    7. A button to remove selected items quantities from stock and update the stock database, a MsgBox should Warn User “You are about to remove items and update the database, Do you want to continue?"
    8. A button to reverse previously rejected/removed item (7 above) back to stock and update the database, a MsgBox should Warn User “You are about to add items and update the database, Do you want to continue?”
    9. A button to clear the Invoice Template of Material data and Price [More like Reset all Field excluding Invoice Number]
    10. Automatically generate a new serial invoice number based on an incremental value of the last logged invoice on pressing the NEW INVOICE Button.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-24-2012
    Location
    Lagos
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Inventory and Invoice Template : Broken Fields and Modifications Required

    My VBA Experts... Help still needed

  3. #3
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Inventory and Invoice Template : Broken Fields and Modifications Required

    Hi fortknox

    When would this happen? Before the Invoice is cleared? After the Invoice has been cleared? Day(s) later?
    Will ALL Invoice items be returned to stock? Only select items?

    8. A button to reverse previously rejected/removed item (7 above) back to stock and update the database, a MsgBox should Warn User “You are about to add items and update the database, Do you want to continue?”
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Registered User
    Join Date
    09-24-2012
    Location
    Lagos
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Inventory and Invoice Template : Broken Fields and Modifications Required

    Quote Originally Posted by jaslake View Post
    Hi fortknox

    When would this happen? Before the Invoice is cleared? After the Invoice has been cleared? Day(s) later?
    Will ALL Invoice items be returned to stock? Only select items?
    The action is expected to take place after an initial removal from stock before/after the invoice is cleared.

  5. #5
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Inventory and Invoice Template : Broken Fields and Modifications Required

    Hi fortknox

    Let's try this again...I'm not sitting in your chair so, I need to understand...When would this happen?

    8. A button to reverse previously rejected/removed item (7 above) back to stock and update the database, a MsgBox should Warn User “You are about to add items and update the database, Do you want to continue?”
    Please answer Yes, No or Maybe...a little explanation of each response would be helpful.

    Before the Invoice is cleared?
    After the Invoice has been cleared?
    Day(s) later?
    Will ALL Invoice items be returned to stock?
    Only select items?

  6. #6
    Registered User
    Join Date
    09-24-2012
    Location
    Lagos
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Inventory and Invoice Template : Broken Fields and Modifications Required

    Quote Originally Posted by jaslake View Post
    Hi fortknox

    Let's try this again...I'm not sitting in your chair so, I need to understand...When would this happen?



    Please answer Yes, No or Maybe...a little explanation of each response would be helpful.

    Before the Invoice is cleared?
    After the Invoice has been cleared?
    Day(s) later?
    Will ALL Invoice items be returned to stock?
    Only select items?
    Jaslake, Thanks and sorry for my ambiguity.

    Before the Invoice is cleared? No
    After the Invoice has been cleared? YES
    Day(s) later? YES
    Will ALL Invoice items be returned to stock? - (Maybe) Only Selected Items or all Items in Invoice as the case may be
    Only select items? - Definitely YES

  7. #7
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Inventory and Invoice Template : Broken Fields and Modifications Required

    Hi fortknox

    Try the Code in the attached...it's too much to post in Code Tags.

    Item 8 has become a two step process. First one must RECALL the Order then indicate which Item(s) to remove (please see the Comment on each Cell in Column D of Invoice). Then Click Return To Stock.

    Play with it. No doubt additional Error Checking will need added. Let me know of issues.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    09-24-2012
    Location
    Lagos
    MS-Off Ver
    Excel 2010
    Posts
    12
    Thanks i will check it out and revert back
    Quote Originally Posted by jaslake View Post
    Hi fortknox

    Try the Code in the attached...it's too much to post in Code Tags.

    Item 8 has become a two step process. First one must RECALL the Order then indicate which Item(s) to remove (please see the Comment on each Cell in Column D of Invoice). Then Click Return To Stock.

    Play with it. No doubt additional Error Checking will need added. Let me know of issues.

  9. #9
    Registered User
    Join Date
    09-24-2012
    Location
    Lagos
    MS-Off Ver
    Excel 2010
    Posts
    12
    [QUOTE=fortknox;4195767]Thanks i will check " Thanks, works great and exceeds my expectations. Hope i get to be as good as you are one day"

  10. #10
    Registered User
    Join Date
    09-24-2012
    Location
    Lagos
    MS-Off Ver
    Excel 2010
    Posts
    12
    Quote Originally Posted by fortknox View Post
    Thanks i will check it out and revert back
    " Thanks, works great and exceeds my expectations. Hope i get to be as good as you are one day"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 10-10-2014, 04:15 PM
  2. i need help for inventory-invoice :)
    By putra5686 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2012, 04:53 AM
  3. Replies: 5
    Last Post: 01-02-2011, 11:06 PM
  4. Inventory Spreadsheet - Transfering count to master broken?
    By turningitred in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2009, 01:24 PM
  5. Invoice inventory
    By stretched in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-06-2007, 11:06 PM
  6. Invoice/Inventory spreadsheet
    By Les in forum Excel General
    Replies: 1
    Last Post: 06-18-2006, 05:05 PM
  7. Replies: 1
    Last Post: 02-28-2005, 03:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1