{"id":433,"date":"2021-10-07T15:58:20","date_gmt":"2021-10-07T14:58:20","guid":{"rendered":"https:\/\/ecommercepreston.co.uk\/?post_type=ht_kb&#038;p=433"},"modified":"2024-06-19T12:34:17","modified_gmt":"2024-06-19T11:34:17","slug":"load-accounts","status":"publish","type":"ht_kb","link":"https:\/\/ibridge.co.uk\/help\/knowledge-base\/load-accounts\/","title":{"rendered":"Load Accounts"},"content":{"rendered":"<p>There are 2 ways in which you can perform Load Accounts in BoB2. The first being via the Import\u00a0 XLS for larger GRNs. The second being a Manual Load Accounts for smaller GRNs. Both methods are detailed below.<\/p>\n<h2>1) Load Accounts via XLS Import<\/h2>\n<p>Navigate to\u00a0<em data-renderer-mark=\"true\"><strong data-renderer-mark=\"true\">BoB2 \u2192 Purchasing\u2192 Load Account Prices<\/strong><\/em><\/p>\n<p>This will display the Load Accounts screen&#8230;<\/p>\n<p><a href=\"https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadacc.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-760\" src=\"https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadacc.png\" alt=\"\" width=\"1662\" height=\"536\" srcset=\"https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadacc.png 1662w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadacc-300x97.png 300w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadacc-1024x330.png 1024w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadacc-768x248.png 768w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadacc-50x16.png 50w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadacc-1536x495.png 1536w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadacc-60x19.png 60w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadacc-100x32.png 100w\" sizes=\"auto, (max-width: 1662px) 100vw, 1662px\" \/><\/a><\/p>\n<h3>a) Importing XLS<\/h3>\n<ul>\n<li>Press &#8220;Choose File&#8221;<\/li>\n<li>Select the XLS from you directory<\/li>\n<li>Press &#8220;Import&#8221;<\/li>\n<\/ul>\n<p>Once imported, the grid below will populate with the records from the XLS.<\/p>\n<p>The next stage is to then validate the records &#8211; Check errors in the error column. If there are errors, press the &#8220;Delete&#8221; button in the top-right, amend the issues in the XLS and then reimport the file.<\/p>\n<p>When there are no errors and you are happy with the data then press &#8220;Apply&#8221;.<\/p>\n<p><a href=\"https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadaccountsresult.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-784\" src=\"https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadaccountsresult.png\" alt=\"\" width=\"1665\" height=\"215\" srcset=\"https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadaccountsresult.png 1665w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadaccountsresult-300x39.png 300w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadaccountsresult-1024x132.png 1024w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadaccountsresult-768x99.png 768w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadaccountsresult-50x6.png 50w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadaccountsresult-1536x198.png 1536w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadaccountsresult-60x8.png 60w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/loadaccountsresult-100x13.png 100w\" sizes=\"auto, (max-width: 1665px) 100vw, 1665px\" \/><\/a><\/p>\n<h3><b>b) Finishing the GRN<\/b><\/h3>\n<p style=\"text-align: left;\">Navigate to\u00a0<em data-renderer-mark=\"true\"><strong data-renderer-mark=\"true\">BoB2 \u2192 Purchasing\u2192 Goods Receipt<\/strong><\/em><\/p>\n<p>Find the GRN. (After importing the accounts via XLS the GRN status will be in the status of &#8220;Awaiting Accounts&#8221;)<\/p>\n<p>Before pressing &#8220;Finished&#8221;, ensure Delivery Reference and Invoice Reference fields are populated. Once &#8220;Finish&#8221; has been pressed this will close the Purchase Order and will mark the GRN as accounts received.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1686\" src=\"https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount.png\" alt=\"\" width=\"3436\" height=\"1622\" srcset=\"https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount.png 3436w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-300x142.png 300w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-1024x483.png 1024w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-768x363.png 768w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-50x24.png 50w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-1536x725.png 1536w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-2048x967.png 2048w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-60x28.png 60w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-100x47.png 100w\" sizes=\"auto, (max-width: 3436px) 100vw, 3436px\" \/><\/p>\n<h2>2) Load Accounts via Manual Load Accounts<\/h2>\n<p>Navigate to\u00a0<em data-renderer-mark=\"true\"><strong data-renderer-mark=\"true\">BoB2 \u2192 Purchasing\u2192 Goods Receipt<\/strong><\/em><\/p>\n<p>Find the GRN you are looking to load the accounts for. (NOTE: In order to manually load the accounts of a GRN, the status of the GRN must be &#8220;Goods Booked In&#8221;)<\/p>\n<h3>a) Manually Entering Load Account Data<\/h3>\n<p>You will notice on the GRN that the columns &#8220;Base Unit Price&#8221; and &#8220;Landed Unit Cost&#8221; are highlighted in green, meaning you are able to edit those fields.<\/p>\n<p>You can click into them to then go and change the value individually and then press TAB to cycle through the records. Once you have entered the values you can press the &#8220;Manual Load Account&#8221; button at the top of the screen.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1685\" src=\"https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/ManualLoadAccounts.png\" alt=\"\" width=\"3385\" height=\"1720\" srcset=\"https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/ManualLoadAccounts.png 3385w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/ManualLoadAccounts-300x152.png 300w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/ManualLoadAccounts-1024x520.png 1024w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/ManualLoadAccounts-768x390.png 768w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/ManualLoadAccounts-50x25.png 50w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/ManualLoadAccounts-1536x780.png 1536w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/ManualLoadAccounts-2048x1041.png 2048w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/ManualLoadAccounts-60x30.png 60w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/ManualLoadAccounts-100x51.png 100w\" sizes=\"auto, (max-width: 3385px) 100vw, 3385px\" \/><\/p>\n<h3>b) Finishing the GRN<\/h3>\n<p>After pressing &#8220;Manual Load Account&#8221;, you will notice the columns have changed to white so they cannot be amended now and a &#8220;Finished&#8221; button has appeared at the top.<\/p>\n<p>Before pressing &#8220;Finished&#8221;, ensure Delivery Reference and Invoice Reference fields are populated.<\/p>\n<p>Once &#8220;Finished&#8221; has been pressed this will close the Purchase Order and will mark the GRN as accounts received.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1686\" src=\"https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount.png\" alt=\"\" width=\"3436\" height=\"1622\" srcset=\"https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount.png 3436w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-300x142.png 300w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-1024x483.png 1024w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-768x363.png 768w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-50x24.png 50w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-1536x725.png 1536w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-2048x967.png 2048w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-60x28.png 60w, https:\/\/ibridge.co.uk\/help\/wp-content\/uploads\/2021\/10\/FinishManualLoadAccount-100x47.png 100w\" sizes=\"auto, (max-width: 3436px) 100vw, 3436px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are 2 ways in which you can perform Load Accounts in BoB2. The first being via the Import\u00a0 XLS for larger GRNs. The second being a Manual Load Accounts for smaller GRNs. Both methods are detailed below. 1) Load Accounts via XLS Import Navigate to\u00a0BoB2 \u2192 Purchasing\u2192 Load Account&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[50],"ht-kb-tag":[],"class_list":["post-433","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-purchasing-2"],"_links":{"self":[{"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/ht-kb\/433","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/comments?post=433"}],"version-history":[{"count":9,"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/ht-kb\/433\/revisions"}],"predecessor-version":[{"id":1689,"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/ht-kb\/433\/revisions\/1689"}],"wp:attachment":[{"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/media?parent=433"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/ht-kb-category?post=433"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/ibridge.co.uk\/help\/wp-json\/wp\/v2\/ht-kb-tag?post=433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}